package com.itheima.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.domain.db.Option;
import org.apache.ibatis.annotations.Select;

import java.util.List;

//问卷
public interface OptionMapper extends BaseMapper<Option> {

    @Select("SELECT question_id, MAX(score) score FROM tb_option GROUP BY question_id;")
    List<Option> queryScoreMaxByQuestionId(List<Long> questionIdList);
}
